<html>
<?php


	$ServProID=$_POST['Ser_Pro_ID'];
	$Fname=$_POST["Fname"];
	$Minit=$_POST["Minit"];
	$Lname=$_POST["Lname"];
	$ServProType=$_POST["Ser_Pro_Type"];
	$Adr=$_POST["Address"];
	$City=$_POST["City"];
	$State=$_POST["State"];
	$Zip=$_POST["Zip"];
	$Uname=$_POST["username"];
	$Pword=$_POST["password"];
	$Email=$_POST["email"];
	

	$col = array();
	$dataTable;
	$dbConn = odbc_connect('EventDB','','');
	$sql = "Insert into ServiceProfessionals values('$ServProID','$Fname','$Minit','$Lname','$ServProType','$Adr','$City','$State','$Zip','$Uname','$Pword','$Email')";
	

	$exec = odbc_exec($dbConn,$sql);
	$numFields = odbc_num_fields($exec);
	
		while($row=odbc_fetch_row($exec))
		{
			for($j=1;$j<$numFields+1;$j++)
			{
				$col[$i]=odbc_result($exec,$i);
				$dataTable +="<td>".$col[$i]."</td>";
			}
			//reproduces data
			echo $data = "<tr>" + $dataTable + "</tr>";
		}


?>
</html>
